<?php session_start();
if (!isset($_SESSION["username"])) {
    header("Location:workerlogin.html");
} else {
    $username = $_SESSION['username'];
    $a = mysqli_connect("localhost", "root", "deng123", "housekeeping", "3306") or die("unable to connect");
    // 如果没有就插入一张卡的信息


    @$query = "SELECT card_no FROM admin_login where username='$username'";
    @$result = mysqli_query($a, $query);

    if ($result) {
        while ($row = mysqli_fetch_array($result)) {
            $dbcard_no = $row['card_no'];
            @$q = "SELECT * FROM credit_card where card_no=$dbcard_no";
            @$res = mysqli_query($a, $q);
            if ($res) {
                while ($row = mysqli_fetch_array($res)) {
                    $dbcard_type = $row['card_type'];
                    $dbname = $row['name'];
                    $dbamount = $row['Amount'];
?>
                    <!DOCTYPE html>
                    <html lang="en">

                    <head>
                        <!-- Required meta tags-->
                        <meta charset="utf-8">
                        <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
                        <meta name="description" content="">
                        <meta name="author" content="">
                        <meta name="viewport" content="width=device-width, initial-scale=1">
                        <title>好先生 | 家政服务</title>
                        <link rel="shortcut icon" href="../img/favicon.ico" />
                        <!-- Icons font CSS-->
                        <link href="../vendor/bootstrap/css/bootstrap.min.css" rel="stylesheet">
                        <link href="../vendor/fontawesome-free/css/all.min.css" rel="stylesheet">
                        <link rel="stylesheet" href="../vendor/simple-line-icons/css/simple-line-icons.css">
                        <link href="https://fonts.googleapis.com/css?family=Lato" rel="stylesheet">
                        <link href="https://fonts.googleapis.com/css?family=Catamaran:100,200,300,400,500,600,700,800,900"
                            rel="stylesheet">
                        <link href="https://fonts.googleapis.com/css?family=Muli" rel="stylesheet">
                        <link href="../vendor/mdi-font/css/material-design-iconic-font.min.css" rel="stylesheet" media="all">
                        <link href="../vendor/font-awesome-4.7/css/font-awesome.min.css" rel="stylesheet" media="all">

                        <!-- Font special for pages-->
                        <link
                            href="https://fonts.googleapis.com/css?family=Poppins:100,100i,200,200i,300,300i,400,400i,500,500i,600,600i,700,700i,800,800i,900,900i"
                            rel="stylesheet">

                        <!-- Vendor CSS-->
                        <link href="../vendor/select2/select2.min.css" rel="stylesheet" media="all">
                        <link href="../css/hover-min.css" rel="stylesheet">


                        <!-- Main CSS-->
                        <link href="../css/style.css" rel="stylesheet" media="all">
                        <link href="../css/main.css" rel="stylesheet" media="all">
                    </head>

                    <body>
                        <nav class="navbar navbar-expand-lg navbar-light fixed-top"
                            style="background:-webkit-gradient(linear, right top, left top, from(#1da1f2), to(#005f7f));"
                            id="mainNav">
                            <div class="container">
                                <div class="navbar-header">
                                    <a class=" nav-link js-scroll-trigger" href="#top">
                                        <img class="img-rounded" src="../img/logo.png" />
                                    </a>
                                </div>
                                &nbsp;
                                <a class="navbar-brand " href="#page-top">
                                    <h2>
                                        <small style="font-family: Arial;border-bottom: 2px solid gainsboro">管理员面板</small>
                                    </h2>
                                </a>
                                <button class="navbar-toggler navbar-toggler-right ml-auto" type="button" data-toggle="collapse"
                                    data-target="#navbarResponsive" aria-controls="navbarResponsive" aria-expanded="false"
                                    aria-label="Toggle navigation">
                                    菜单
                                    <i class="fas fa-bars"></i>
                                </button>
                                <div class="collapse navbar-collapse" id="navbarResponsive">
                                    <ul class="navbar-nav ml-auto">
                                        <li class="nav-item">
                                            <a class="nav-link js-scroll-trigger hvr-glow" href="profile.php">详情</a>
                                        </li>
                                        <li class="nav-item">
                                            <a class="nav-link js-scroll-trigger hvr-glow " href="workers.php">员工</a>
                                        </li>
                                        <li class="nav-item">
                                            <a class="nav-link js-scroll-trigger hvr-glow " href="customers.php">顾客</a>
                                        </li>
                                        <li class="nav-item">
                                            <a class="nav-link js-scroll-trigger hvr-glow " href="bookings.php">预定</a>
                                        </li>
                                        <li class="nav-item">
                                            <a class="nav-link js-scroll-trigger hvr-glow " href="queries.php">反馈</a>
                                        </li>
                                        <li class="nav-item">
                                            <a class="nav-link js-scroll-trigger hvr-glow " href="logout.php">退出</a>
                                        </li>
                                    </ul>
                                </div>
                            </div>
                        </nav>
                        <section class="features tb bb" id="features">
                            <form action="profile.php" method="post">
                                <input type="submit" class="cont_button2 btn-dark" value="<< 返回">
                            </form>
                            <h1 class="mb-4 text-light">银行卡详情</h1>
                            <table class="container1">
                                <tbody>
                                    <tr>
                                        <td>卡类型</td>
                                        <td><?php echo $dbcard_type; ?></td>
                                    </tr>
                                    <tr>
                                        <td>卡号</td>
                                        <td><?php echo $dbcard_no; ?></td>
                                    </tr>
                                    <tr>
                                        <td>持卡人名字</td>
                                        <td><?php echo $dbname; ?></td>
                                    </tr>
                                    <tr>
                                        <td>余额</td>
                                        <td><?php echo $dbamount; ?></td>
                                    </tr>
                                </tbody>
                            </table>
                            <div class="container1">
                                <form action="card_edit.php" method="post">
                                    <button id="contact_btn" type="submit" class="contact_button trans_100" style="float: right;" value="编辑">编辑</button>
                                </form>
                            </div>
                        </section>
                        <!-- Jquery JS-->
                        <script src="../vendor/jquery1/jquery.min.js"></script>
                        <!-- Vendor JS-->
                        <script src="../vendor/select2/select2.min.js"></script>
                        <script src="../vendor/jquery-validate/jquery.validate.min.js"></script>
                        <script src="../vendor/bootstrap-wizard/bootstrap.min.js"></script>
                        <script src="../vendor/bootstrap-wizard/jquery.bootstrap.wizard.min.js"></script>
                        <script src="../vendor/datepicker/moment.min.js"></script>
                        <script src="../vendor/datepicker/daterangepicker.js"></script>
                        <script src="../vendor/jquery/jquery.min.js"></script>
                        <script src="../vendor/bootstrap/js/bootstrap.bundle.min.js"></script>

                        <!-- Plugin JavaScript -->
                        <script src="../vendor/jquery-easing/jquery.easing.min.js"></script>


                        <script src="../js/new-age.min.js"></script>

                        <!-- Main JS-->
                        <script src="../js/global.js"></script>
                        <footer>
                            <div class="container">
                                <p>&copy; 好先生 家政服务. 版权所有.</p>
                                <ul class="list-inline">
                                    <li class="list-inline-item">
                                        <a href="#">隐私</a>
                                    </li>
                                    <li class="list-inline-item">
                                        <a href="#">条款</a>
                                    </li>
                                </ul>
                            </div>
                        </footer>
                    </body>
                    <!-- end document-->

                    </html>
<?php
                }
            }
        }
    }
}
?>